MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Geography Type = 72

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Period, Dynasty, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Country, Region, Subregion, Locale, Excavation

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
351214 62.200 1 1 543903 Egyptian Art 19 Statue, striding man 17584 Striding Figure   Old Kingdom Dynasty 4 12                       ca. 2575–2465 B.C. -2575 -2575 Quartzite, paint 55635 H. 89.5 cm (35 1/4 in.) Harris Brisbane Dick Fund, 1962 Possibly from|From 72   | 96   Egypt 104 Southern Upper Egypt 647 ElKab 140             Metropolitan Museum of Art, New York, NY 1
351495 17.9.2 1 1 544186 Egyptian Art 19 Sphinx, Senwosret III 17790 Senwosret III as a Sphinx   Middle Kingdom Dynasty 12 2 reign of Senwosret III 36                     ca. 1878–1840 B.C. -1878 -1840 Gneiss 25715 L. 73 × W. 29.5 × H. 42.5 cm, 114.3 kg (28 3/4 × 11 5/8 × 16 3/4 in., 252 lb.) Gift of Edward S. Harkness, 1917 Possibly from|From 72   | 96   Egypt 104 Upper Egypt, Thebes 646 Karnak 173             Metropolitan Museum of Art, New York, NY 1
354619 01.4.92 0 1 547397 Egyptian Art 19 Game counter, knuckle bone 19580 Knuckle Bone   Early Dynastic Period Dynasty 1 4 reign of Den? 184                     ca. 3100–2900 B.C. -3100 -2900 Bone 4752 L: 3.2 cm (1 1/4 in.); w: 2.1 cm (13/16 in.) Gift of Egypt Exploration Fund, 1901 Possibly from|From 72   | 96   Egypt 104 Northern Upper Egypt 644 Abydos 142 Umm el-Qaab 316 Tomb of Den 555 Egypt Exploration Fund excavations 103       Metropolitan Museum of Art, New York, NY 1
355802 26.2.54 0 1 548675 Egyptian Art 19 Door Jamb, Rau 20215 Door Jamb of Rau   New Kingdom Dynasty 18 21 reign of Thutmose III 31                     ca. 1479–1425 B.C. -1479 -1479 Limestone 1737 H. 146.5 cm (57 11/16 in.); w 23.5 cm (9 1/4 in.) Rogers Fund, 1926 Possibly from|From 72   | 96   Egypt 104 Upper Egypt, Thebes 646 Dra Abu el-Naga 179             Metropolitan Museum of Art, New York, NY 1
359250 26.7.982a–c 0 1 552609 Egyptian Art 19 Winged Goddess 22055 Winged Goddess   Late New Kingdom or early Third Intermediate Period Dynasty 19–22 239                       ca. 1295–712 B.C. -1295 -712 Faience 781 H. 11.5 x W. 23.6 cm (4 1/2 x 9 5/16 in.) Purchase, Edward S. Harkness Gift, 1926 Possibly from|From 72   | 96   Egypt|Egypt 494 Northern Upper Egypt 644 Abydos 142             Metropolitan Museum of Art, New York, NY 1
360453 01.4.125 0 0 553845 Egyptian Art 19 Chisel 1700 Chisel   New Kingdom Dynasty 18 21                       ca. 1550–1295 B.C. -1550 -1295 Bronze or copper alloy 55660 l. 8.6 cm (3 3/8 in) Gift of the Egypt Exploration Fund, 1900 Possibly from|From 72   | 96   Egypt 104 Northern Upper Egypt 644 Abydos 142 Cemetery D 164 Tomb 99 955 Egypt Exploration Fund excavations 103       Metropolitan Museum of Art, New York, NY 1
362371 21.10.49 0 0 555821 Egyptian Art 19 Lamp 558 Lamp   Middle Kingdom Dynasty 12 2                       ca. 2030–1802 B.C. -2030 -1802 Pottery 7419 Diam. 11 cm (4 5/16 in.) Gift of British School of Archaeology, 1921 Possibly from|From 72   | 96   Egypt 104 Fayum Entrance Area 650 Lahun 147 Tomb 618 603   BSAE excavations, 1919-1920 275       Metropolitan Museum of Art, New York, NY 1
371465 01.4.142 0 0 567757 Egyptian Art 19 Scarab, Ra 25247 Scarab   New Kingdom, Ramesside Dynasty 19 45                       ca. 1295–1186 B.C. -1295 -1186 Faience 781 L. 0.8 cm (5/16 in.) Gift of the Egypt Exploration Fund, 1900 Possibly from|From 72   | 96   Egypt 104 Northern Upper Egypt 644 Abydos 142 Cemetery D 164 Tomb 76 1249 Egypt Exploration Fund excavations 103   | 259   Metropolitan Museum of Art, New York, NY 1
377485 SL.3.2015.3.1 0 0 591201 Egyptian Art 19 Statue of Two Governors in a Prostrate Pose 26403 Statue Group with Two Prostrate Men   Middle Kingdom Dynasty 12 2                       ca. 1981-1802 B.C. -1986 -1976 Red-brown quartzite 57655 H. 11 cm (4 5/16 in.); W. 27.5 cm (10 13/16 in.); D. 28 cm (11 in.) The Walters Art Museum, Baltimore, Maryland (Acquired by Henry Walters), 22.373 Possibly from|From 72   | 96   Egypt 104   Dahshur 213             Metropolitan Museum of Art, New York, NY 1
377528 SL.3.2015.22.1 0 0 591312 Egyptian Art 19 Upper Part of the Statue of a Mummiform Deity 26446 Upper Part of the Statue of a Mummiform Deity   Middle Kingdom Dynasty 12 2                       ca. 1981-1802 B.C. -1986 -1976 Limestone 1737 18 11/16 × 14 9/16 × 7 5/16 in. (47.5 × 37 × 18.5 cm) Musée cantonal des Beaux-arts de Lausanne, Switzerland. Legs Henri-Auguste Widmer, 1939 Possibly from|From 72   | 96   Egypt 104 Memphite Region 645 Memphis 266             Metropolitan Museum of Art, New York, NY 1
377542 SL.3.2015.25.14 0 0 591333 Egyptian Art 19 Statue of the Mayor Rehuankh Seated 26460 Statue of the Mayor Rehuankh Seated   Middle Kingdom Dynasty 12 2                       ca. 1981-1802 B.C. -1986 -1976 Quartzite 28872 29 1/2 × 10 1/2 × 18 1/8 in. (75 × 26.7 × 46 cm) The Trustees of the British Museum, London Possibly from|From 72   | 96   Egypt 104   Abydos 142             Metropolitan Museum of Art, New York, NY 1
377587 SL.3.2015.32.9 0 0 591411 Egyptian Art 19 Statue of the Priest Amenemhatankh Standing 26501 Statue of the Priest Amenemhatankh Standing   Middle Kingdom Dynasty 12 2 Amenemhat III 353                     ca. 1859-1813 B.C. -1864 -1854 Quartzite 28872 with restoration of feet that no longer exists: 28 3/8 × 7 1/16 × 11 15/16 in. (72 × 18 × 30.3 cm) Paris, Louvre Museum, Departement des Antiquités égyptiennes Possibly from|From 72   | 96   Egypt 104   Fayum 363             Metropolitan Museum of Art, New York, NY 1
377596 SL.3.2015.36.3 0 0 591438 Egyptian Art 19 Stela of the Trustworthy Sealer Seneb 26510 Stela of the Trustworthy Sealer Seneb   Middle Kingdom                         ca. 2030-1640 B.C. -2035 -2025 Limestone 1737 31 5/16 × 20 1/16 × 3 15/16 in. (79.5 × 51 × 10 cm) Kunsthistorisches Museum Vienna, Ägyptisch-Orientalische Sammlung Possibly from|From 72   | 96   Egypt 104   Abydos 142             Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 120.513ms · Data license: CC0 · Data source: metmuseum/openaccess